home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 4 / developer source - volume 4.iso / oracl / sep95 / perkf101.gif < prev    next >
Graphics Interchange Format  |  1996-06-11  |  239KB  |  464x1268  |  4-bit (16 colors)
Labels: text | line | screenshot | parallel | diagram | document
OCR: FIGURE 1: The following charts show the results of three components of our parallel query option tests on an Oracle7 Release 7.1.6 system configured with three CPUs. Using the parallel query option can significantly decrease your elapsed time while having a minimal effect on your CPU consumption. Note: CPU time is in 5995-1100A CPU seconds. Elapsed Time CPU Time Parallel Query (aggregate) 200 150 100 50 Seconds 3 5 7 10 15 Degree of Parallelism Parallel SQL'Load, with Direct = True 400 300 200 100 Seconds 3 5 15 Degree of Parallelism Parallel Index Create 200 150 100 50 Seconds 5 7 10 15 Degree of Parallelism The results above are based Software on the following test-system Oracle7 for MVS configuration and database Release 7.1.6.2.50 layout: SQL Load 7.1.6.2.50 Pro*C 1.6.7 Hardware IBM C/370 V2 R1 MO Processor: Amdahl 5995-1100A MVS/ESA V4.3.0 rated at approximately 85 MIPS Database Layout Memory: 634 megabyte central Tablespace for EMPI MIDX Index: storage; 512-megabyte expanded 15 extents of 5 cylinders each 1 storage number column DASD controller: Amdahl 6100 300 DASD cache controller with Tablespace for EMPIM Table: 15 extents of 55 cylinders each 1 28-megabyte coche EMPIM Table Sizing: DASD: 30 Amdahl 6390-2 and 1,000,000 rows 6390-3 DASD 27 columns per row Channels: 12 channels available to Occupies 43,478 blocks MVS DASD Roughly 23 rows per block